Complete Microsoft Office Skills (Beginn

"To enrol please click here Delivery: Online - start and study anytime with tutor support Our introductory and advanced course rolled all into one! In this course, you will learn the basics and then expand upon your knowledge of Word, Excel and PowerPoint. This will be shown through successfully completing beginner upto professional tasks, such as: mail merges, pivot tables, multimedia presentations, and many more. Once you have completed this course, you’ll be in good stead to use your skills and knowledge to excel in an office-based career, move on to further education or secure an apprenticeship. - Learn the basics of the computer - Windows - what it is, what it does and what it includes: calculator, sticky notes, Microsoft Edge - Learn how to use a web browser and email effectively, create a work focused email address using Microsoft Outlook or Gmail and investigate their free online applications Word -Document setup and styles -Headers and footers -Cover and content pages -Collaborate with others using track changes and comments -And use mail merge to create multiple copies of the same document to be send to different people. Excel -Advanced formula and functions including - Count, CountIF, CountA -Understand and use Vlookup -Introduce Pivot tables -Use multiple worksheets in a spreadsheet workbook -Graphs PowerPoint - Be able to format a presentation. - Importing text from another application into a presentation - Customising a PowerPoint design - Add media and animations to a presentation - How to collaborate when creating a presentation - Recording a presentation includes exercises so you can practice what you have learned. Course length - 16 hours. To enrol please click here"